SQL, moving million records from a database to other database [migrated]
Posted
by
Ryoma
on Programmers
See other posts from Programmers
or by Ryoma
Published on 2013-10-24T23:45:00Z
Indexed on
2013/10/25
4:14 UTC
Read the original article
Hit count: 426
sql
|sql-server
I am a C# developer, I am not really good with SQL. I have a simple questions here. I need to move more than 50 millions records from a database to other database. I tried to use the import function in ms SQL, however it got stuck because the log was full (I got an error message The transaction log for database 'mydatabase' is full due to 'LOG_BACKUP'). The database recovery model was set to simple. My friend said that importing millions records using task->import data will cause the log to be massive and told me to use loop instead to transfer the data, does anyone know how and why? thanks in advance
© Programmers or respective owner